package com.dingding.service.activity.core.sql;

/**
 * @ClassName: ActivityRelUserSQL
 * @Description: 活动和用户管理关系表操作SQL
 * @author CHEHUANBO
 * @date 2016年4月4日 上午9:47:33
 * 
 */
public class ActivityRelUserSQL {

	/**
	 * 根据用户用户ID获取用户和活动关联关系
	 * 
	 * @author CHEHUANBO
	 * 
	 */
	public static final String GET_ACTIVITYTRELUSER_BY_USERID = " FROM ActivityRelUser aru WHERE aru.loginId = ? AND aru.activityId =? AND aru.activityType = ?";

	/**
	 * 添加用户参加活动次数
	 * @author CHEHUANBO
	 * 
	 */
	public static final String ADD_USERATTENDACTIVITY_NUMBER = "UPDATE activityreluser arl SET arl.drawNumber = arl.drawNumber + 1 WHERE arl.activityId = ? AND arl.activityType = ? AND arl.loginId = ?";

}
